#include "main.h"

int main(int argc, char *argv[])
{
    dkbg();
    char sql3[512];
    int data2;
    sprintf(sql3, "SELECT * FROM 员工请假 WHERE name ='李四'"); // 查看驳回的请求
    char **ppResult2;
    int row2;
    int col2;
    data2 = sqlite3_get_table(db, sql3, &ppResult2, &row2, &col2, &emsg);
    printf("data2=%d row2=%d col2=%d\n", data2, row2, col2);
    for (int i = 0; i < row2 * col2 + col2; i++)
    {
        printf("data2=%d,%s\n", data2, ppResult2[i]);
    }

    char sql[512];
    sprintf(sql, "CREATE TABLE student(name varchar(255),balance float,jifen float);");
    _sqlite3_exec(db, sql);

    sprintf(sql, "DROP TABLE student;");//暴力删除整个表格
    _sqlite3_exec(db, sql);
    
}